{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Analysis of Mcdonald" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Please answer the following questions based on Mcdonald CSV" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 1. Plot graphically which food categories have the highest and lowest varieties." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 2. Which all variables have an outlier?" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 3. Which variables have the highest correlation? Plot them and find out the value?" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 4. Which category contributes to the maximum % of Cholesterol in a diet (% daily value)?" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 5. Which item contributes maximum to the Sodium intake?" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 6. Which 4 food items contain the most amount of Saturated Fat?" ] }, { "cell_type": "code", "execution_count": 47, "metadata": {}, "outputs": [], "source": [ "# Import lib for the data set" ] }, { "cell_type": "code", "execution_count": 70, "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import seaborn as sns\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline\n", "from warnings import filterwarnings\n", "filterwarnings(\"ignore\")\n", "pd.set_option('display.float_format', lambda x: '%.2f' % x)\n", "import scipy.stats as stats\n", "import pandas_profiling as pdpro" ] }, { "cell_type": "code", "execution_count": 49, "metadata": {}, "outputs": [], "source": [ "# Get the Data\n", "df = pd.read_csv('Mcdonald.csv')" ] }, { "cell_type": "code", "execution_count": 50, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | Category | \n", "Item | \n", "Serving Size | \n", "Calories | \n", "Calories from Fat | \n", "Total Fat | \n", "Total Fat (% Daily Value) | \n", "Saturated Fat | \n", "Saturated Fat (% Daily Value) | \n", "Trans Fat | \n", "... | \n", "Carbohydrates | \n", "Carbohydrates (% Daily Value) | \n", "Dietary Fiber | \n", "Dietary Fiber (% Daily Value) | \n", "Sugars | \n", "Protein | \n", "Vitamin A (% Daily Value) | \n", "Vitamin C (% Daily Value) | \n", "Calcium (% Daily Value) | \n", "Iron (% Daily Value) | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "Breakfast | \n", "Egg McMuffin | \n", "4.8 oz (136 g) | \n", "300 | \n", "120 | \n", "13.00 | \n", "20 | \n", "5.00 | \n", "25 | \n", "0.00 | \n", "... | \n", "31 | \n", "10 | \n", "4 | \n", "17 | \n", "3 | \n", "17 | \n", "10 | \n", "0 | \n", "25 | \n", "15 | \n", "
| 1 | \n", "Breakfast | \n", "Egg White Delight | \n", "4.8 oz (135 g) | \n", "250 | \n", "70 | \n", "8.00 | \n", "12 | \n", "3.00 | \n", "15 | \n", "0.00 | \n", "... | \n", "30 | \n", "10 | \n", "4 | \n", "17 | \n", "3 | \n", "18 | \n", "6 | \n", "0 | \n", "25 | \n", "8 | \n", "
| 2 | \n", "Breakfast | \n", "Sausage McMuffin | \n", "3.9 oz (111 g) | \n", "370 | \n", "200 | \n", "23.00 | \n", "35 | \n", "8.00 | \n", "42 | \n", "0.00 | \n", "... | \n", "29 | \n", "10 | \n", "4 | \n", "17 | \n", "2 | \n", "14 | \n", "8 | \n", "0 | \n", "25 | \n", "10 | \n", "
| 3 | \n", "Breakfast | \n", "Sausage McMuffin with Egg | \n", "5.7 oz (161 g) | \n", "450 | \n", "250 | \n", "28.00 | \n", "43 | \n", "10.00 | \n", "52 | \n", "0.00 | \n", "... | \n", "30 | \n", "10 | \n", "4 | \n", "17 | \n", "2 | \n", "21 | \n", "15 | \n", "0 | \n", "30 | \n", "15 | \n", "
| 4 | \n", "Breakfast | \n", "Sausage McMuffin with Egg Whites | \n", "5.7 oz (161 g) | \n", "400 | \n", "210 | \n", "23.00 | \n", "35 | \n", "8.00 | \n", "42 | \n", "0.00 | \n", "... | \n", "30 | \n", "10 | \n", "4 | \n", "17 | \n", "2 | \n", "21 | \n", "6 | \n", "0 | \n", "25 | \n", "10 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 255 | \n", "Smoothies & Shakes | \n", "McFlurry with Oreo Cookies (Small) | \n", "10.1 oz (285 g) | \n", "510 | \n", "150 | \n", "17.00 | \n", "26 | \n", "9.00 | \n", "44 | \n", "0.50 | \n", "... | \n", "80 | \n", "27 | \n", "1 | \n", "4 | \n", "64 | \n", "12 | \n", "15 | \n", "0 | \n", "40 | \n", "8 | \n", "
| 256 | \n", "Smoothies & Shakes | \n", "McFlurry with Oreo Cookies (Medium) | \n", "13.4 oz (381 g) | \n", "690 | \n", "200 | \n", "23.00 | \n", "35 | \n", "12.00 | \n", "58 | \n", "1.00 | \n", "... | \n", "106 | \n", "35 | \n", "1 | \n", "5 | \n", "85 | \n", "15 | \n", "20 | \n", "0 | \n", "50 | \n", "10 | \n", "
| 257 | \n", "Smoothies & Shakes | \n", "McFlurry with Oreo Cookies (Snack) | \n", "6.7 oz (190 g) | \n", "340 | \n", "100 | \n", "11.00 | \n", "17 | \n", "6.00 | \n", "29 | \n", "0.00 | \n", "... | \n", "53 | \n", "18 | \n", "1 | \n", "2 | \n", "43 | \n", "8 | \n", "10 | \n", "0 | \n", "25 | \n", "6 | \n", "
| 258 | \n", "Smoothies & Shakes | \n", "McFlurry with Reese's Peanut Butter Cups (Medium) | \n", "14.2 oz (403 g) | \n", "810 | \n", "290 | \n", "32.00 | \n", "50 | \n", "15.00 | \n", "76 | \n", "1.00 | \n", "... | \n", "114 | \n", "38 | \n", "2 | \n", "9 | \n", "103 | \n", "21 | \n", "20 | \n", "0 | \n", "60 | \n", "6 | \n", "
| 259 | \n", "Smoothies & Shakes | \n", "McFlurry with Reese's Peanut Butter Cups (Snack) | \n", "7.1 oz (202 g) | \n", "410 | \n", "150 | \n", "16.00 | \n", "25 | \n", "8.00 | \n", "38 | \n", "0.00 | \n", "... | \n", "57 | \n", "19 | \n", "1 | \n", "5 | \n", "51 | \n", "10 | \n", "10 | \n", "0 | \n", "30 | \n", "4 | \n", "
260 rows × 24 columns
\n", "